Field Value Lists

A Field Value List is a tool used to provide drop-down menu options for specific ERP fields during journal creation. You can create different Field Value Lists by assigning a unique name and linking each list to a configured ERP Field. Mapping a list to a field enables system validations that check requirements like data type and character limits. The display format of each field can be adjusted by selecting either Stored Value, Display Value, or Both as the Display Option. Selecting Stored Value or Display Value will show only that respective value, while choosing Both will present them together.

IMPORTANT: Only the Stored Values are sent to the ERP system, so validation only occurs against this value's data type and character limit attributes.

After the Field Value List attributes are defined, you can enter values to display in the drop-down menu. This page includes the following validations:

  • The Stored Value must be unique, within the character limit specified for the related ERP field, and match the required data type for that field.

  • If Display Option is set to Display Value, a corresponding value must be entered for the Display Value.

    NOTE: When set to Both, the Display Value is optional, but the Stored Value is required. If no Display Value is entered, the user will see only the Stored Value.

  • Display Value must be less than or equal to 200 characters.

Field Value List Grid

Once a Field Value List is added, it displays in the Field Value List grid. See Grid Toolbar.

Import and Export of Field Value Lists

Field Value Lists can be created manually using the UI of Journal Entry Manager. For situations involving large volumes of data, you can use the import process for creating or editing journal entries

Select the Template button to download an unpopulated import file. This file contains the same fields and available values as those shown in the UI, enabling users to complete it offline.

Users can also select an existing Field Value List and select Export to download a populated import file for that specific Field Value List. All drop-down menu options from the Journal Entry Manager UI are included in both the Excel template and export, along with the documented validations.

After creating or editing a Field Value List, click Import to upload the import file.

NOTE: Users can only upload one file at a time.

IMPORTANT: Excel formulas within the template are now ignored during import. Only values are processed. This prevents errors and supports more flexible spreadsheet use.

Automated Field Value List Import

Administrators can use the folder structure and a data management job to automatically import journal entries into Journal Entry Manager using Task Scheduler. This setting is managed at the ERP level. On each ERP, set the Enable Auto Field Value List Import option to Yes. GetFieldValueListlmports data management job searches for the specified parent folder for each individual ERP's Connection Type. See Connections. You are required to set up sub-folders with the following folder name:

  • FieldValueList

When Field Value Lists are ready for import, they must be placed within the Field Value List folder and use the following file name format: OneStream_JEM_FieldValueList_. Additional text may be appended to the end of the filename as needed.

Folder Hierarchy Example:

  • Journal Entries: This folder is selected on the Connections page and appiled to the ERP.

  • FieldValueList: This folder contains all Field Value Lists that will be imported.

IMPORTANT: All these sub-folders must be created manually. They are not automatically created during the installation of Journal Entry Manager.

Import

  1. Go to ERPs > Field Value Lists.

  2. Click the Import button to import Field Value Lists for your ERP.

  3. Click the Browse button or drop your file within the File Upload dialog box.

  4. Use File Explorer to browse and select the file you want to import.

  5. Click the Open button.

  6. Click the Upload button.

Template

  1. Click the Template button to download a template to import.

  2. The JEM_FieldValueList_Template.xlsx file is automatically downloaded to your default downloads location.

    IMPORTANT: Ensure that you click the Enable Editing button on the Excel Sheet.

  3. Fill out the following fields under Field Value List:

    1. Enter a name.

    2. From the ERP Field drop-down menu, select a field.

    3. From the Display Option drop-down menu, select an option.

  4. Fill out the following fields under Field Values:

    1. Enter a Stored Value.

    2. Enter a Display Value.

      NOTE: Inset new rows between the bars.

  5. Save your file.

Export

  1. Select an existing ERP Field Value List you want to export.

  2. Click the Export button.

  3. The JEM_FieldValueList_Export.xlsx file is automatically downloaded to your default downloads location.